Part 1 of 1 -

Question 1 of 205.0 Points
The most important function of a database is the ability to __________ the data in order to find the responding data that relates to the question.
  A.  create 
  B.  query 
  C.  delete 
  D.  macro 
Reset Selection

Mark for Review What's This?
Question 2 of 205.0 Points
__________ are displayed in rows, and each category is known as a field.
  A.  Files 
  B.  Data Types 
  C.  Records 
  D.  Designs 
Reset Selection

Mark for Review What's This?
Question 3 of 205.0 Points
When in the single form layout, you will be viewing a:
  A.  record 
  B.  table 
  C.  field 
  D.  macro 
Reset Selection

Mark for Review What's This?
Question 4 of 205.0 Points
An easy way to skip to the last record in a table is to click the Â in the Navigation:
  A.  bar at the bottom of the screen. 
  B.  bar at the top of the screen. 
  C.  pane. 
  D.  group on the Home tab ribbon. 
Reset Selection

Mark for Review What's This?
Question 5 of 205.0 Points
The easiest way to jump from field to field in order to input data when in the single form layout is to use the:
  A.  mouse. 
  B.  Tab key. 
  C.  Ctrl key. 
  D.  Spacebar. 
Reset Selection

Mark for Review What's This?
Question 6 of 205.0 Points
You are nearly finished inputting a new record when you find that you are inputting the wrong information. The easiest way to start over is to press the __________ key.
  A.  Tab 
  B.  Spacebar 
  C.  Page up 
  D.  Esc 
Reset Selection

Mark for Review What's This?
Question 7 of 205.0 Points
In order to perform a query on an Access database, you must provide a list of:
  A.  records. 
  B.  tables. 
  C.  forms. 
  D.  criteria. 
Reset Selection

Mark for Review What's This?
Question 8 of 205.0 Points
Which of the selections below describes a key difference between viewing data in a table and viewing in a report?
  A.  The data displayed in a report doesn't match the data found in a table. 
  B.  Tables only show data that has been queried. 
  C.  The data in a report cannot be changed, unlike a table. 
  D.  The data in a table cannot be changed, unlike a report. 
Reset Selection

Mark for Review What's This?
Question 9 of 205.0 Points
You want to make formatting changes to the tables in your Access database by the Datasheet Formatting dialog box. You need to access this dialog box in the dialog box launcher in the _________ group on the Home tab ribbon
  A.  Table 
  B.  Cell 
  C.  Font 
  D.  DataSheet 
Reset Selection

Mark for Review What's This?
Question 10 of 205.0 Points
What is the maximum number of alpha-numeric characters that you can type into a field in Access 2007?
  A.  16 
  B.  55 
  C.  199 
  D.  255 
Reset Selection

Mark for Review What's This?
Question 11 of 205.0 Points
You click the  button while viewing a table. What happens as a result?
  A.  A new record is created and displayed as an Append row. 
  B.  A new field is created and displayed as an Append row. 
  C.  A new field is created and displayed as an Append column. 
  D.  A new table is created and is displayed in a new window. 
Reset Selection

Mark for Review What's This?
Question 12 of 205.0 Points
What will happen to the data you are viewing in an Access Table as a result of clicking the  button?

  A.  Access will perform a Search and Replace operation. 
  B.  Access will sort the data in alphabetical order. 
  C.  Access will show all the data that matches the input criteria. 
  D.  Access will delete all of the data in the selected field. 
Reset Selection

Mark for Review What's This?
Question 13 of 205.0 Points
You are viewing a table made up of nearly two dozen columns. You only want to view half of them in Access 2007. You need to highlight the undesired columns and:
  A.  press the delete key. 
  B.  click the Delete Columns button. 
  C.  click the hide Fields button. 
  D.  click the Hide Columns button. 
Reset Selection

Mark for Review What's This?
Question 14 of 205.0 Points
How do you know if you are viewing filtered or unfiltered data in a table?
  A.  Look at the Filter checkbox in the Sort and Filter group. 
  B.  Look at the Filter button in the Sort and Filter group. 
  C.  Look at the Filter status bar. 
  D.  Look to see if the Filter tab appears on the ribbon. 
Reset Selection

Mark for Review What's This?
Question 15 of 205.0 Points
You wish to print the filtered data you are viewing. How do you access the Print command?
  A.  Click the Print Table button on the Home tab ribbon. 
  B.  Click the Office button and select the Print command. 
  C.  Click the Print Records button on the Home tab ribbon. 
  D.  Press the Shift + P keys on the keyboard. 
Reset Selection

Mark for Review What's This?
Question 16 of 205.0 Points
In order to have a relational database, you must have two or more tables that share:
  A.  a common field. 
  B.  a common record. 
  C.  the same data. 
  D.  the same filter group. 
Reset Selection

Mark for Review What's This?
Question 17 of 205.0 Points
You are looking at two tables that are connected to each other after clicking the Relationships tab. What does this mean?
  A.  The two tables were created from the same template. 
  B.  The two tables share data redundancy. 
  C.  The two tables are related. 
  D.  One of the tables was created from the other. 
Reset Selection

Mark for Review What's This?
Question 18 of 205.0 Points
What is the easiest way to display fields within a table that has been assigned the Date/time data type?
  A.  Click the Filter toggle button and select Date and Time. 
  B.  Click the Filter toggle button and check the Date and Time checkbox. 
  C.  Click the Date Picker button. 
  D.  Click the Date and Time button in the Data group. 
Reset Selection

Mark for Review What's This?
Question 19 of 205.0 Points
When in Report Layout view, how can you tell if a label is selected?
  A.  The label blinks. 
  B.  The label is highlighted. 
  C.  The label is active. 
  D.  The label has an orange border. 
Reset Selection

Mark for Review What's This?
Question 20 of 205.0 Points
What is a key benefit of the Compact and Repair tool in Access 2007?
  A.  It eliminates data redundancy. 
  B.  It decreases the size of the database file. 
  C.  It eliminates non alpha-numeric characters from the records. 
  D.  It converts a 2007 database to the 2003 file format.